Overview

Dataset statistics

Number of variables17
Number of observations42896
Missing cells52072
Missing cells (%)7.1%
Duplicate rows906
Duplicate rows (%)2.1%
Total size in memory5.6 MiB
Average record size in memory136.0 B

Variable types

Numeric11
Categorical6

Alerts

type has constant value "audio_features"Constant
Dataset has 906 (2.1%) duplicate rowsDuplicates
song_name has a high cardinality: 15439 distinct valuesHigh cardinality
title has a high cardinality: 132 distinct valuesHigh cardinality
energy is highly overall correlated with loudness and 1 other fieldsHigh correlation
loudness is highly overall correlated with energyHigh correlation
acousticness is highly overall correlated with energy and 1 other fieldsHigh correlation
instrumentalness is highly overall correlated with acousticness and 1 other fieldsHigh correlation
duration_ms is highly overall correlated with instrumentalnessHigh correlation
time_signature is highly imbalanced (84.3%)Imbalance
loudness has 9170 (21.4%) missing valuesMissing
song_name has 21085 (49.2%) missing valuesMissing
title has 21817 (50.9%) missing valuesMissing
song_name is uniformly distributedUniform
key has 3520 (8.2%) zerosZeros
instrumentalness has 11473 (26.7%) zerosZeros

Reproduction

Analysis started2023-01-12 08:12:19.903619
Analysis finished2023-01-12 08:12:56.871020
Duration36.97 seconds
Software versionpandas-profiling vdev
Download configurationconfig.json

Variables

danceability
Real number (ℝ)

Distinct921
Distinct (%)2.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.63933611
Minimum0.0651
Maximum0.988
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size335.2 KiB
2023-01-12T09:12:57.356083image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/

Quantile statistics

Minimum0.0651
5-th percentile0.378
Q10.524
median0.646
Q30.766
95-th percentile0.878
Maximum0.988
Range0.9229
Interquartile range (IQR)0.242

Descriptive statistics

Standard deviation0.15658499
Coefficient of variation (CV)0.24491811
Kurtosis-0.48618557
Mean0.63933611
Median Absolute Deviation (MAD)0.121
Skewness-0.265132
Sum27424.962
Variance0.024518859
MonotonicityNot monotonic
2023-01-12T09:12:57.611781image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.804 193
 
0.4%
0.808 166
 
0.4%
0.8 154
 
0.4%
0.802 153
 
0.4%
0.805 150
 
0.3%
0.803 150
 
0.3%
0.809 141
 
0.3%
0.81 136
 
0.3%
0.807 134
 
0.3%
0.792 126
 
0.3%
Other values (911) 41393
96.5%
ValueCountFrequency (%)
0.0651 2
< 0.1%
0.0753 1
< 0.1%
0.0891 2
< 0.1%
0.0979 1
< 0.1%
0.106 2
< 0.1%
0.111 1
< 0.1%
0.116 1
< 0.1%
0.119 1
< 0.1%
0.121 1
< 0.1%
0.123 1
< 0.1%
ValueCountFrequency (%)
0.988 3
< 0.1%
0.985 4
< 0.1%
0.984 1
 
< 0.1%
0.983 2
< 0.1%
0.982 1
 
< 0.1%
0.981 1
 
< 0.1%
0.98 2
< 0.1%
0.979 2
< 0.1%
0.978 3
< 0.1%
0.977 2
< 0.1%

energy
Real number (ℝ)

Distinct955
Distinct (%)2.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.76256045
Minimum0.000243
Maximum1
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size335.2 KiB
2023-01-12T09:12:57.879999image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/

Quantile statistics

Minimum0.000243
5-th percentile0.425
Q10.632
median0.803
Q30.923
95-th percentile0.982
Maximum1
Range0.999757
Interquartile range (IQR)0.291

Descriptive statistics

Standard deviation0.18369117
Coefficient of variation (CV)0.24088736
Kurtosis-0.20130099
Mean0.76256045
Median Absolute Deviation (MAD)0.135
Skewness-0.73716286
Sum32710.793
Variance0.033742448
MonotonicityNot monotonic
2023-01-12T09:12:58.152115image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.977 191
 
0.4%
0.953 172
 
0.4%
0.988 171
 
0.4%
0.97 170
 
0.4%
0.956 169
 
0.4%
0.924 165
 
0.4%
0.963 162
 
0.4%
0.98 159
 
0.4%
0.951 159
 
0.4%
0.942 158
 
0.4%
Other values (945) 41220
96.1%
ValueCountFrequency (%)
0.000243 2
< 0.1%
0.000602 1
< 0.1%
0.0127 1
< 0.1%
0.0148 1
< 0.1%
0.0223 1
< 0.1%
0.0279 2
< 0.1%
0.0297 1
< 0.1%
0.0321 1
< 0.1%
0.0393 1
< 0.1%
0.0453 1
< 0.1%
ValueCountFrequency (%)
1 5
 
< 0.1%
0.999 22
 
0.1%
0.999 3
 
< 0.1%
0.998 87
0.2%
0.997 94
0.2%
0.996 100
0.2%
0.995 123
0.3%
0.994 144
0.3%
0.994 4
 
< 0.1%
0.993 133
0.3%

key
Real number (ℝ)

Distinct12
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.3685658
Minimum0
Maximum11
Zeros3520
Zeros (%)8.2%
Negative0
Negative (%)0.0%
Memory size335.2 KiB
2023-01-12T09:12:58.382854image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q11
median6
Q39
95-th percentile11
Maximum11
Range11
Interquartile range (IQR)8

Descriptive statistics

Standard deviation3.6649926
Coefficient of variation (CV)0.68267629
Kurtosis-1.365958
Mean5.3685658
Median Absolute Deviation (MAD)4
Skewness-0.00095694629
Sum230290
Variance13.432171
MonotonicityNot monotonic
2023-01-12T09:12:58.555585image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)
ValueCountFrequency (%)
1 7641
17.8%
7 4332
10.1%
11 4197
9.8%
6 3767
8.8%
0 3520
8.2%
8 3405
7.9%
10 3294
7.7%
9 3293
7.7%
2 3093
7.2%
5 3047
 
7.1%
Other values (2) 3307
7.7%
ValueCountFrequency (%)
0 3520
8.2%
1 7641
17.8%
2 3093
7.2%
3 910
 
2.1%
4 2397
 
5.6%
5 3047
 
7.1%
6 3767
8.8%
7 4332
10.1%
8 3405
7.9%
9 3293
7.7%
ValueCountFrequency (%)
11 4197
9.8%
10 3294
7.7%
9 3293
7.7%
8 3405
7.9%
7 4332
10.1%
6 3767
8.8%
5 3047
7.1%
4 2397
5.6%
3 910
 
2.1%
2 3093
7.2%

loudness
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct11257
Distinct (%)33.4%
Missing9170
Missing (%)21.4%
Infinite0
Infinite (%)0.0%
Mean-6.4638994
Minimum-32.929
Maximum3.148
Zeros1
Zeros (%)< 0.1%
Negative33562
Negative (%)78.2%
Memory size335.2 KiB
2023-01-12T09:12:58.792523image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/

Quantile statistics

Minimum-32.929
5-th percentile-11.626
Q1-8.165
median-6.2285
Q3-4.52
95-th percentile-2.00625
Maximum3.148
Range36.077
Interquartile range (IQR)3.645

Descriptive statistics

Standard deviation2.9381711
Coefficient of variation (CV)-0.45455087
Kurtosis1.4448485
Mean-6.4638994
Median Absolute Deviation (MAD)1.817
Skewness-0.62893063
Sum-218001.47
Variance8.6328493
MonotonicityNot monotonic
2023-01-12T09:12:59.054936image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
-6.142 19
 
< 0.1%
-6.186 17
 
< 0.1%
-5.892 16
 
< 0.1%
-5.943 16
 
< 0.1%
-5.572 15
 
< 0.1%
-5.334 15
 
< 0.1%
-5.531 15
 
< 0.1%
-4.162 15
 
< 0.1%
-7.641 15
 
< 0.1%
-5.545 14
 
< 0.1%
Other values (11247) 33569
78.3%
(Missing) 9170
 
21.4%
ValueCountFrequency (%)
-32.929 1
< 0.1%
-26.172 1
< 0.1%
-26.113 1
< 0.1%
-24.694 1
< 0.1%
-24.563 1
< 0.1%
-24.203 1
< 0.1%
-23.577 1
< 0.1%
-23.39 1
< 0.1%
-23.385 1
< 0.1%
-23.035 1
< 0.1%
ValueCountFrequency (%)
3.148 1
< 0.1%
2.499 1
< 0.1%
2.363 1
< 0.1%
2.185 1
< 0.1%
1.949 1
< 0.1%
1.877 1
< 0.1%
1.851 1
< 0.1%
1.85 1
< 0.1%
1.833 1
< 0.1%
1.792 1
< 0.1%

mode
Categorical

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size335.2 KiB
1
23571 
0
19325 

Length

Max length1
Median length1
Mean length1
Min length1

Characters and Unicode

Total characters42896
Distinct characters2
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1
2nd row1
3rd row1
4th row1
5th row1

Common Values

ValueCountFrequency (%)
1 23571
54.9%
0 19325
45.1%

Length

2023-01-12T09:12:59.304465image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-01-12T09:12:59.528948image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
ValueCountFrequency (%)
1 23571
54.9%
0 19325
45.1%

Most occurring characters

ValueCountFrequency (%)
1 23571
54.9%
0 19325
45.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 42896
100.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 23571
54.9%
0 19325
45.1%

Most occurring scripts

ValueCountFrequency (%)
Common 42896
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
1 23571
54.9%
0 19325
45.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 42896
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 23571
54.9%
0 19325
45.1%

speechiness
Real number (ℝ)

Distinct1474
Distinct (%)3.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.13644625
Minimum0.0227
Maximum0.946
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size335.2 KiB
2023-01-12T09:12:59.749163image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/

Quantile statistics

Minimum0.0227
5-th percentile0.0348
Q10.0491
median0.0754
Q30.193
95-th percentile0.398
Maximum0.946
Range0.9233
Interquartile range (IQR)0.1439

Descriptive statistics

Standard deviation0.12597627
Coefficient of variation (CV)0.92326664
Kurtosis2.889166
Mean0.13644625
Median Absolute Deviation (MAD)0.0347
Skewness1.6715108
Sum5852.9984
Variance0.015870021
MonotonicityNot monotonic
2023-01-12T09:13:00.016108image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.102 123
 
0.3%
0.106 116
 
0.3%
0.105 115
 
0.3%
0.109 113
 
0.3%
0.111 112
 
0.3%
0.11 110
 
0.3%
0.113 106
 
0.2%
0.107 104
 
0.2%
0.114 100
 
0.2%
0.124 96
 
0.2%
Other values (1464) 41801
97.4%
ValueCountFrequency (%)
0.0227 2
< 0.1%
0.0232 2
< 0.1%
0.0235 1
 
< 0.1%
0.0238 1
 
< 0.1%
0.0239 1
 
< 0.1%
0.0241 1
 
< 0.1%
0.0242 3
< 0.1%
0.0243 1
 
< 0.1%
0.0244 2
< 0.1%
0.0245 1
 
< 0.1%
ValueCountFrequency (%)
0.946 1
 
< 0.1%
0.944 1
 
< 0.1%
0.914 1
 
< 0.1%
0.908 3
< 0.1%
0.906 1
 
< 0.1%
0.905 1
 
< 0.1%
0.902 2
< 0.1%
0.898 1
 
< 0.1%
0.89 1
 
< 0.1%
0.888 1
 
< 0.1%

acousticness
Real number (ℝ)

Distinct4707
Distinct (%)11.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.096260315
Minimum1.07 × 10-6
Maximum0.988
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size335.2 KiB
2023-01-12T09:13:00.284837image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/

Quantile statistics

Minimum1.07 × 10-6
5-th percentile8.9475 × 10-5
Q10.00173
median0.0164
Q30.107
95-th percentile0.497
Maximum0.988
Range0.98799893
Interquartile range (IQR)0.10527

Descriptive statistics

Standard deviation0.17084273
Coefficient of variation (CV)1.7747992
Kurtosis6.5271008
Mean0.096260315
Median Absolute Deviation (MAD)0.016194
Skewness2.5299953
Sum4129.1825
Variance0.029187238
MonotonicityNot monotonic
2023-01-12T09:13:00.554748image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.128 75
 
0.2%
0.114 74
 
0.2%
0.106 69
 
0.2%
0.125 69
 
0.2%
0.0138 68
 
0.2%
0.105 61
 
0.1%
0.0105 60
 
0.1%
0.102 57
 
0.1%
0.111 57
 
0.1%
0.133 56
 
0.1%
Other values (4697) 42250
98.5%
ValueCountFrequency (%)
1.07 × 10-61
< 0.1%
1.14 × 10-61
< 0.1%
1.21 × 10-61
< 0.1%
1.46 × 10-61
< 0.1%
1.81 × 10-61
< 0.1%
1.83 × 10-61
< 0.1%
1.93 × 10-61
< 0.1%
2.14 × 10-61
< 0.1%
2.43 × 10-61
< 0.1%
2.46 × 10-61
< 0.1%
ValueCountFrequency (%)
0.988 1
 
< 0.1%
0.987 1
 
< 0.1%
0.986 2
< 0.1%
0.985 1
 
< 0.1%
0.984 1
 
< 0.1%
0.983 1
 
< 0.1%
0.982 2
< 0.1%
0.98 1
 
< 0.1%
0.978 3
< 0.1%
0.976 3
< 0.1%

instrumentalness
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct4867
Distinct (%)11.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.28322936
Minimum0
Maximum0.989
Zeros11473
Zeros (%)26.7%
Negative0
Negative (%)0.0%
Memory size335.2 KiB
2023-01-12T09:13:00.830116image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.00596
Q30.722
95-th percentile0.909
Maximum0.989
Range0.989
Interquartile range (IQR)0.722

Descriptive statistics

Standard deviation0.37081022
Coefficient of variation (CV)1.3092224
Kurtosis-1.2495296
Mean0.28322936
Median Absolute Deviation (MAD)0.00596
Skewness0.75166777
Sum12149.407
Variance0.13750022
MonotonicityNot monotonic
2023-01-12T09:13:01.104719image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 11473
 
26.7%
0.871 93
 
0.2%
0.897 90
 
0.2%
0.901 85
 
0.2%
0.895 85
 
0.2%
0.858 79
 
0.2%
0.874 79
 
0.2%
0.865 78
 
0.2%
0.892 77
 
0.2%
0.883 77
 
0.2%
Other values (4857) 30680
71.5%
ValueCountFrequency (%)
0 11473
26.7%
1 × 10-65
 
< 0.1%
1.01 × 10-613
 
< 0.1%
1.02 × 10-613
 
< 0.1%
1.03 × 10-613
 
< 0.1%
1.04 × 10-616
 
< 0.1%
1.05 × 10-67
 
< 0.1%
1.06 × 10-613
 
< 0.1%
1.07 × 10-69
 
< 0.1%
1.08 × 10-67
 
< 0.1%
ValueCountFrequency (%)
0.989 3
< 0.1%
0.988 1
 
< 0.1%
0.987 1
 
< 0.1%
0.986 1
 
< 0.1%
0.985 1
 
< 0.1%
0.983 1
 
< 0.1%
0.982 1
 
< 0.1%
0.981 6
< 0.1%
0.979 2
 
< 0.1%
0.978 4
< 0.1%

liveness
Real number (ℝ)

Distinct1737
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.21408004
Minimum0.0107
Maximum0.988
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size335.2 KiB
2023-01-12T09:13:01.391907image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/

Quantile statistics

Minimum0.0107
5-th percentile0.0615
Q10.0996
median0.135
Q30.294
95-th percentile0.61825
Maximum0.988
Range0.9773
Interquartile range (IQR)0.1944

Descriptive statistics

Standard deviation0.17546346
Coefficient of variation (CV)0.81961618
Kurtosis3.0811814
Mean0.21408004
Median Absolute Deviation (MAD)0.0546
Skewness1.7803261
Sum9183.1773
Variance0.030787427
MonotonicityNot monotonic
2023-01-12T09:13:01.731866image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.111 689
 
1.6%
0.109 487
 
1.1%
0.107 455
 
1.1%
0.11 443
 
1.0%
0.106 432
 
1.0%
0.105 368
 
0.9%
0.102 364
 
0.8%
0.114 349
 
0.8%
0.113 348
 
0.8%
0.115 316
 
0.7%
Other values (1727) 38645
90.1%
ValueCountFrequency (%)
0.0107 1
 
< 0.1%
0.0121 3
< 0.1%
0.0135 1
 
< 0.1%
0.0141 3
< 0.1%
0.0147 1
 
< 0.1%
0.0149 1
 
< 0.1%
0.0153 3
< 0.1%
0.0159 1
 
< 0.1%
0.0182 1
 
< 0.1%
0.0188 1
 
< 0.1%
ValueCountFrequency (%)
0.988 1
 
< 0.1%
0.981 2
 
< 0.1%
0.979 1
 
< 0.1%
0.978 3
< 0.1%
0.976 1
 
< 0.1%
0.975 5
< 0.1%
0.973 2
 
< 0.1%
0.97 1
 
< 0.1%
0.969 1
 
< 0.1%
0.968 1
 
< 0.1%

valence
Real number (ℝ)

Distinct1716
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.3571699
Minimum0.0187
Maximum0.988
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size335.2 KiB
2023-01-12T09:13:02.096966image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/

Quantile statistics

Minimum0.0187
5-th percentile0.0436
Q10.161
median0.322
Q30.522
95-th percentile0.797
Maximum0.988
Range0.9693
Interquartile range (IQR)0.361

Descriptive statistics

Standard deviation0.23325546
Coefficient of variation (CV)0.65306582
Kurtosis-0.60890607
Mean0.3571699
Median Absolute Deviation (MAD)0.175
Skewness0.54957366
Sum15321.16
Variance0.054408108
MonotonicityNot monotonic
2023-01-12T09:13:02.409227image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.142 99
 
0.2%
0.158 97
 
0.2%
0.144 93
 
0.2%
0.186 92
 
0.2%
0.141 91
 
0.2%
0.175 90
 
0.2%
0.15 88
 
0.2%
0.178 88
 
0.2%
0.152 87
 
0.2%
0.159 87
 
0.2%
Other values (1706) 41984
97.9%
ValueCountFrequency (%)
0.0187 2
< 0.1%
0.0196 3
< 0.1%
0.0199 1
 
< 0.1%
0.0206 3
< 0.1%
0.0218 3
< 0.1%
0.0228 1
 
< 0.1%
0.0235 1
 
< 0.1%
0.0236 1
 
< 0.1%
0.0237 1
 
< 0.1%
0.0239 2
< 0.1%
ValueCountFrequency (%)
0.988 1
 
< 0.1%
0.98 3
< 0.1%
0.979 1
 
< 0.1%
0.976 2
 
< 0.1%
0.975 4
< 0.1%
0.974 2
 
< 0.1%
0.973 1
 
< 0.1%
0.972 3
< 0.1%
0.971 4
< 0.1%
0.97 5
< 0.1%

tempo
Real number (ℝ)

Distinct15569
Distinct (%)36.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean147.49209
Minimum57.967
Maximum220.29
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size335.2 KiB
2023-01-12T09:13:02.733970image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/

Quantile statistics

Minimum57.967
5-th percentile115.82175
Q1129.91875
median144.9705
Q3161.5975
95-th percentile192.8865
Maximum220.29
Range162.323
Interquartile range (IQR)31.67875

Descriptive statistics

Standard deviation23.861654
Coefficient of variation (CV)0.1617826
Kurtosis0.10894812
Mean147.49209
Median Absolute Deviation (MAD)15.455
Skewness0.47899078
Sum6326820.5
Variance569.37851
MonotonicityNot monotonic
2023-01-12T09:13:03.015901image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
150.02 59
 
0.1%
125 57
 
0.1%
149.998 51
 
0.1%
125.002 50
 
0.1%
128 49
 
0.1%
150 48
 
0.1%
149.992 47
 
0.1%
125.007 46
 
0.1%
123.999 46
 
0.1%
128.005 44
 
0.1%
Other values (15559) 42399
98.8%
ValueCountFrequency (%)
57.967 1
< 0.1%
61.309 1
< 0.1%
64.331 1
< 0.1%
64.934 1
< 0.1%
64.95 1
< 0.1%
66.424 1
< 0.1%
67.003 1
< 0.1%
69.986 1
< 0.1%
70.022 1
< 0.1%
70.231 1
< 0.1%
ValueCountFrequency (%)
220.29 1
< 0.1%
220.232 1
< 0.1%
220.216 1
< 0.1%
220.154 1
< 0.1%
220.152 1
< 0.1%
220.148 2
< 0.1%
220.138 1
< 0.1%
220.13 1
< 0.1%
220.112 1
< 0.1%
220.102 1
< 0.1%

type
Categorical

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size335.2 KiB
audio_features
42896 

Length

Max length14
Median length14
Mean length14
Min length14

Characters and Unicode

Total characters600544
Distinct characters11
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowaudio_features
2nd rowaudio_features
3rd rowaudio_features
4th rowaudio_features
5th rowaudio_features

Common Values

ValueCountFrequency (%)
audio_features 42896
100.0%

Length

2023-01-12T09:13:03.267454image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-01-12T09:13:03.474854image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
ValueCountFrequency (%)
audio_features 42896
100.0%

Most occurring characters

ValueCountFrequency (%)
a 85792
14.3%
u 85792
14.3%
e 85792
14.3%
d 42896
7.1%
i 42896
7.1%
o 42896
7.1%
_ 42896
7.1%
f 42896
7.1%
t 42896
7.1%
r 42896
7.1%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 557648
92.9%
Connector Punctuation 42896
 
7.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
a 85792
15.4%
u 85792
15.4%
e 85792
15.4%
d 42896
7.7%
i 42896
7.7%
o 42896
7.7%
f 42896
7.7%
t 42896
7.7%
r 42896
7.7%
s 42896
7.7%
Connector Punctuation
ValueCountFrequency (%)
_ 42896
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 557648
92.9%
Common 42896
 
7.1%

Most frequent character per script

Latin
ValueCountFrequency (%)
a 85792
15.4%
u 85792
15.4%
e 85792
15.4%
d 42896
7.7%
i 42896
7.7%
o 42896
7.7%
f 42896
7.7%
t 42896
7.7%
r 42896
7.7%
s 42896
7.7%
Common
ValueCountFrequency (%)
_ 42896
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 600544
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
a 85792
14.3%
u 85792
14.3%
e 85792
14.3%
d 42896
7.1%
i 42896
7.1%
o 42896
7.1%
_ 42896
7.1%
f 42896
7.1%
t 42896
7.1%
r 42896
7.1%

duration_ms
Real number (ℝ)

Distinct26261
Distinct (%)61.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean250913.57
Minimum25600
Maximum913052
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size335.2 KiB
2023-01-12T09:13:03.701517image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/

Quantile statistics

Minimum25600
5-th percentile121186
Q1179971.25
median224663
Q3301288.5
95-th percentile457973.25
Maximum913052
Range887452
Interquartile range (IQR)121317.25

Descriptive statistics

Standard deviation102979.76
Coefficient of variation (CV)0.41041926
Kurtosis0.49528913
Mean250913.57
Median Absolute Deviation (MAD)54250
Skewness0.95262368
Sum1.0763189 × 1010
Variance1.0604831 × 1010
MonotonicityNot monotonic
2023-01-12T09:13:03.976122image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
192000 105
 
0.2%
240000 87
 
0.2%
224000 68
 
0.2%
211200 57
 
0.1%
230400 57
 
0.1%
172800 52
 
0.1%
217600 49
 
0.1%
236800 43
 
0.1%
268800 43
 
0.1%
168000 39
 
0.1%
Other values (26251) 42296
98.6%
ValueCountFrequency (%)
25600 1
< 0.1%
35862 1
< 0.1%
38333 1
< 0.1%
41290 1
< 0.1%
42133 1
< 0.1%
43807 1
< 0.1%
48107 1
< 0.1%
48423 1
< 0.1%
48667 1
< 0.1%
49227 1
< 0.1%
ValueCountFrequency (%)
913052 1
< 0.1%
894386 1
< 0.1%
855502 1
< 0.1%
847302 1
< 0.1%
821168 1
< 0.1%
774294 1
< 0.1%
757972 1
< 0.1%
752000 1
< 0.1%
728413 1
< 0.1%
723573 2
< 0.1%

time_signature
Categorical

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size335.2 KiB
4
40999 
3
 
1227
5
 
519
1
 
151

Length

Max length1
Median length1
Mean length1
Min length1

Characters and Unicode

Total characters42896
Distinct characters4
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row4
2nd row4
3rd row4
4th row3
5th row4

Common Values

ValueCountFrequency (%)
4 40999
95.6%
3 1227
 
2.9%
5 519
 
1.2%
1 151
 
0.4%

Length

2023-01-12T09:13:04.196085image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-01-12T09:13:04.426812image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
ValueCountFrequency (%)
4 40999
95.6%
3 1227
 
2.9%
5 519
 
1.2%
1 151
 
0.4%

Most occurring characters

ValueCountFrequency (%)
4 40999
95.6%
3 1227
 
2.9%
5 519
 
1.2%
1 151
 
0.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 42896
100.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
4 40999
95.6%
3 1227
 
2.9%
5 519
 
1.2%
1 151
 
0.4%

Most occurring scripts

ValueCountFrequency (%)
Common 42896
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
4 40999
95.6%
3 1227
 
2.9%
5 519
 
1.2%
1 151
 
0.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 42896
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4 40999
95.6%
3 1227
 
2.9%
5 519
 
1.2%
1 151
 
0.4%

genre
Categorical

Distinct15
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size335.2 KiB
Underground Rap
5948 
Dark Trap
4634 
Hiphop
3080 
trance
3038 
techhouse
3019 
Other values (10)
23177 

Length

Max length15
Median length10
Mean length7.6035761
Min length3

Characters and Unicode

Total characters326163
Distinct characters29
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowDark Trap
2nd rowDark Trap
3rd rowDark Trap
4th rowDark Trap
5th rowDark Trap

Common Values

ValueCountFrequency (%)
Underground Rap 5948
13.9%
Dark Trap 4634
10.8%
Hiphop 3080
 
7.2%
trance 3038
 
7.1%
techhouse 3019
 
7.0%
dnb 3017
 
7.0%
trap 3014
 
7.0%
techno 3007
 
7.0%
psytrance 3003
 
7.0%
hardstyle 2981
 
6.9%
Other values (5) 8155
19.0%

Length

2023-01-12T09:13:04.634374image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
trap 9632
17.4%
rap 7818
14.1%
underground 5948
10.7%
dark 4634
8.4%
hiphop 3080
 
5.6%
trance 3038
 
5.5%
techhouse 3019
 
5.4%
dnb 3017
 
5.4%
techno 3007
 
5.4%
psytrance 3003
 
5.4%
Other values (5) 9266
16.7%

Most occurring characters

ValueCountFrequency (%)
r 35184
 
10.8%
a 33090
 
10.1%
p 27081
 
8.3%
n 26089
 
8.0%
e 25999
 
8.0%
t 20046
 
6.1%
d 17894
 
5.5%
o 17227
 
5.3%
h 15106
 
4.6%
12566
 
3.9%
Other values (19) 95881
29.4%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 277086
85.0%
Uppercase Letter 36511
 
11.2%
Space Separator 12566
 
3.9%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
r 35184
12.7%
a 33090
11.9%
p 27081
9.8%
n 26089
9.4%
e 25999
9.4%
t 20046
7.2%
d 17894
 
6.5%
o 17227
 
6.2%
h 15106
 
5.5%
c 12067
 
4.4%
Other values (9) 47303
17.1%
Uppercase Letter
ValueCountFrequency (%)
R 9946
27.2%
T 6618
18.1%
U 5948
16.3%
D 4634
12.7%
H 3080
 
8.4%
B 2128
 
5.8%
M 1984
 
5.4%
E 1705
 
4.7%
P 468
 
1.3%
Space Separator
ValueCountFrequency (%)
12566
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 313597
96.1%
Common 12566
 
3.9%

Most frequent character per script

Latin
ValueCountFrequency (%)
r 35184
11.2%
a 33090
 
10.6%
p 27081
 
8.6%
n 26089
 
8.3%
e 25999
 
8.3%
t 20046
 
6.4%
d 17894
 
5.7%
o 17227
 
5.5%
h 15106
 
4.8%
c 12067
 
3.8%
Other values (18) 83814
26.7%
Common
ValueCountFrequency (%)
12566
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 326163
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
r 35184
 
10.8%
a 33090
 
10.1%
p 27081
 
8.3%
n 26089
 
8.0%
e 25999
 
8.0%
t 20046
 
6.1%
d 17894
 
5.5%
o 17227
 
5.3%
h 15106
 
4.6%
12566
 
3.9%
Other values (19) 95881
29.4%

song_name
Categorical

HIGH CARDINALITY  MISSING  UNIFORM 

Distinct15439
Distinct (%)70.8%
Missing21085
Missing (%)49.2%
Memory size335.2 KiB
Forever
 
14
Lost
 
12
Hollow
 
12
Numb
 
12
Revenge
 
11
Other values (15434)
21750 

Length

Max length138
Median length94
Mean length15.5058
Min length1

Characters and Unicode

Total characters338197
Distinct characters190
Distinct categories15 ?
Distinct scripts8 ?
Distinct blocks9 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique11537 ?
Unique (%)52.9%

Sample

1st rowMercury: Retrograde
2nd rowPathology
3rd rowSymbiote
4th rowProductOfDrugs (Prod. The Virus and Antidote)
5th rowVenom

Common Values

ValueCountFrequency (%)
Forever 14
 
< 0.1%
Lost 12
 
< 0.1%
Hollow 12
 
< 0.1%
Numb 12
 
< 0.1%
Revenge 11
 
< 0.1%
Scars 11
 
< 0.1%
PTSD 11
 
< 0.1%
Alone 11
 
< 0.1%
Runaway 11
 
< 0.1%
Leave Me Alone 10
 
< 0.1%
Other values (15429) 21696
50.6%
(Missing) 21085
49.2%

Length

2023-01-12T09:13:04.920100image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
feat 2494
 
4.0%
the 1698
 
2.7%
1655
 
2.6%
you 760
 
1.2%
me 759
 
1.2%
i 725
 
1.2%
a 589
 
0.9%
my 514
 
0.8%
it 500
 
0.8%
of 467
 
0.7%
Other values (10934) 52297
83.7%

Most occurring characters

ValueCountFrequency (%)
40647
 
12.0%
e 29068
 
8.6%
a 19569
 
5.8%
o 17404
 
5.1%
t 16500
 
4.9%
i 15879
 
4.7%
n 13890
 
4.1%
r 12634
 
3.7%
l 10336
 
3.1%
s 10038
 
3.0%
Other values (180) 152232
45.0%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 207102
61.2%
Uppercase Letter 71342
 
21.1%
Space Separator 40647
 
12.0%
Other Punctuation 7651
 
2.3%
Open Punctuation 3463
 
1.0%
Close Punctuation 3460
 
1.0%
Decimal Number 3109
 
0.9%
Dash Punctuation 851
 
0.3%
Currency Symbol 363
 
0.1%
Math Symbol 118
 
< 0.1%
Other values (5) 91
 
< 0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
e 29068
14.0%
a 19569
 
9.4%
o 17404
 
8.4%
t 16500
 
8.0%
i 15879
 
7.7%
n 13890
 
6.7%
r 12634
 
6.1%
l 10336
 
5.0%
s 10038
 
4.8%
h 8056
 
3.9%
Other values (63) 53728
25.9%
Uppercase Letter
ValueCountFrequency (%)
T 5662
 
7.9%
S 5232
 
7.3%
A 4274
 
6.0%
M 4123
 
5.8%
I 4024
 
5.6%
B 3928
 
5.5%
L 3859
 
5.4%
D 3822
 
5.4%
R 3452
 
4.8%
C 3212
 
4.5%
Other values (39) 29754
41.7%
Other Letter
ValueCountFrequency (%)
1
 
5.3%
ד 1
 
5.3%
ה 1
 
5.3%
מ 1
 
5.3%
ו 1
 
5.3%
ס 1
 
5.3%
1
 
5.3%
1
 
5.3%
1
 
5.3%
1
 
5.3%
Other values (9) 9
47.4%
Other Punctuation
ValueCountFrequency (%)
. 3783
49.4%
' 1446
 
18.9%
& 868
 
11.3%
, 699
 
9.1%
! 259
 
3.4%
? 169
 
2.2%
/ 156
 
2.0%
* 97
 
1.3%
" 89
 
1.2%
: 44
 
0.6%
Other values (7) 41
 
0.5%
Decimal Number
ValueCountFrequency (%)
2 627
20.2%
0 621
20.0%
1 579
18.6%
4 254
8.2%
3 223
 
7.2%
5 199
 
6.4%
6 197
 
6.3%
9 194
 
6.2%
8 113
 
3.6%
7 102
 
3.3%
Math Symbol
ValueCountFrequency (%)
+ 63
53.4%
| 44
37.3%
< 7
 
5.9%
> 3
 
2.5%
= 1
 
0.8%
Open Punctuation
ValueCountFrequency (%)
( 3375
97.5%
[ 87
 
2.5%
{ 1
 
< 0.1%
Close Punctuation
ValueCountFrequency (%)
) 3374
97.5%
] 85
 
2.5%
} 1
 
< 0.1%
Initial Punctuation
ValueCountFrequency (%)
2
50.0%
1
25.0%
1
25.0%
Dash Punctuation
ValueCountFrequency (%)
- 850
99.9%
1
 
0.1%
Final Punctuation
ValueCountFrequency (%)
39
95.1%
2
 
4.9%
Space Separator
ValueCountFrequency (%)
40647
100.0%
Currency Symbol
ValueCountFrequency (%)
$ 363
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 26
100.0%
Other Symbol
ValueCountFrequency (%)
° 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 278097
82.2%
Common 59734
 
17.7%
Cyrillic 345
 
0.1%
Hangul 7
 
< 0.1%
Hebrew 5
 
< 0.1%
Katakana 5
 
< 0.1%
Greek 2
 
< 0.1%
Han 2
 
< 0.1%

Most frequent character per script

Latin
ValueCountFrequency (%)
e 29068
 
10.5%
a 19569
 
7.0%
o 17404
 
6.3%
t 16500
 
5.9%
i 15879
 
5.7%
n 13890
 
5.0%
r 12634
 
4.5%
l 10336
 
3.7%
s 10038
 
3.6%
h 8056
 
2.9%
Other values (69) 124723
44.8%
Common
ValueCountFrequency (%)
40647
68.0%
. 3783
 
6.3%
( 3375
 
5.7%
) 3374
 
5.6%
' 1446
 
2.4%
& 868
 
1.5%
- 850
 
1.4%
, 699
 
1.2%
2 627
 
1.0%
0 621
 
1.0%
Other values (39) 3444
 
5.8%
Cyrillic
ValueCountFrequency (%)
е 37
 
10.7%
а 31
 
9.0%
о 29
 
8.4%
и 23
 
6.7%
н 23
 
6.7%
р 20
 
5.8%
с 16
 
4.6%
у 12
 
3.5%
л 11
 
3.2%
т 11
 
3.2%
Other values (31) 132
38.3%
Hangul
ValueCountFrequency (%)
1
14.3%
1
14.3%
1
14.3%
1
14.3%
1
14.3%
1
14.3%
1
14.3%
Hebrew
ValueCountFrequency (%)
ד 1
20.0%
ה 1
20.0%
מ 1
20.0%
ו 1
20.0%
ס 1
20.0%
Katakana
ValueCountFrequency (%)
1
20.0%
1
20.0%
1
20.0%
1
20.0%
1
20.0%
Greek
ValueCountFrequency (%)
Δ 1
50.0%
Ξ 1
50.0%
Han
ValueCountFrequency (%)
1
50.0%
1
50.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 337682
99.8%
Cyrillic 345
 
0.1%
None 98
 
< 0.1%
Punctuation 52
 
< 0.1%
Hangul 7
 
< 0.1%
Hebrew 5
 
< 0.1%
Katakana 5
 
< 0.1%
CJK 2
 
< 0.1%
Sup Punctuation 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
40647
 
12.0%
e 29068
 
8.6%
a 19569
 
5.8%
o 17404
 
5.2%
t 16500
 
4.9%
i 15879
 
4.7%
n 13890
 
4.1%
r 12634
 
3.7%
l 10336
 
3.1%
s 10038
 
3.0%
Other values (82) 151717
44.9%
Punctuation
ValueCountFrequency (%)
39
75.0%
5
 
9.6%
2
 
3.8%
2
 
3.8%
2
 
3.8%
1
 
1.9%
1
 
1.9%
Cyrillic
ValueCountFrequency (%)
е 37
 
10.7%
а 31
 
9.0%
о 29
 
8.4%
и 23
 
6.7%
н 23
 
6.7%
р 20
 
5.8%
с 16
 
4.6%
у 12
 
3.5%
л 11
 
3.2%
т 11
 
3.2%
Other values (31) 132
38.3%
None
ValueCountFrequency (%)
é 31
31.6%
ø 16
16.3%
á 8
 
8.2%
Ø 4
 
4.1%
4
 
4.1%
à 3
 
3.1%
ó 3
 
3.1%
ñ 2
 
2.0%
ý 2
 
2.0%
É 2
 
2.0%
Other values (20) 23
23.5%
CJK
ValueCountFrequency (%)
1
50.0%
1
50.0%
Hebrew
ValueCountFrequency (%)
ד 1
20.0%
ה 1
20.0%
מ 1
20.0%
ו 1
20.0%
ס 1
20.0%
Hangul
ValueCountFrequency (%)
1
14.3%
1
14.3%
1
14.3%
1
14.3%
1
14.3%
1
14.3%
1
14.3%
Sup Punctuation
ValueCountFrequency (%)
1
100.0%
Katakana
ValueCountFrequency (%)
1
20.0%
1
20.0%
1
20.0%
1
20.0%
1
20.0%

title
Categorical

HIGH CARDINALITY  MISSING 

Distinct132
Distinct (%)0.6%
Missing21817
Missing (%)50.9%
Memory size335.2 KiB
Euphoric Hardstyle
 
1416
UKF Drum & Bass - All Uploads
 
921
Top Trance Songs EVER
 
782
I'm a fucking Headbanger
 
719
Dark Techno Rave
 
692
Other values (127)
16549 

Length

Max length49
Median length37
Mean length22.348546
Min length4

Characters and Unicode

Total characters471085
Distinct characters71
Distinct categories9 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowDirtybird Players
2nd rowTech House Movement
3rd rowtech house
4th rowTech House Bangerz
5th rowtech house

Common Values

ValueCountFrequency (%)
Euphoric Hardstyle 1416
 
3.3%
UKF Drum & Bass - All Uploads 921
 
2.1%
Top Trance Songs EVER 782
 
1.8%
I'm a fucking Headbanger 719
 
1.7%
Dark Techno Rave 692
 
1.6%
Liqduicity Drum & Bass 643
 
1.5%
PSYTRANCE BANGERS best new 2020 620
 
1.4%
Headbangers:Dubstep/Riddim 538
 
1.3%
Dirtybird//Techhouse by Mack\ 518
 
1.2%
HEADBANGERS:Dubstep/Riddim 510
 
1.2%
Other values (122) 13720
32.0%
(Missing) 21817
50.9%

Length

2023-01-12T09:13:05.240838image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
5310
 
7.0%
2020 4148
 
5.5%
trance 3894
 
5.2%
hardstyle 3072
 
4.1%
techno 3065
 
4.1%
bass 3014
 
4.0%
drum 2963
 
3.9%
psytrance 2637
 
3.5%
euphoric 2066
 
2.7%
house 2065
 
2.7%
Other values (142) 43109
57.2%

Most occurring characters

ValueCountFrequency (%)
54284
 
11.5%
e 33420
 
7.1%
s 25916
 
5.5%
a 25025
 
5.3%
r 22909
 
4.9%
o 18765
 
4.0%
n 17752
 
3.8%
c 17585
 
3.7%
i 17407
 
3.7%
t 15676
 
3.3%
Other values (61) 222346
47.2%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 287208
61.0%
Uppercase Letter 87354
 
18.5%
Space Separator 54284
 
11.5%
Decimal Number 25729
 
5.5%
Other Punctuation 11290
 
2.4%
Dash Punctuation 2169
 
0.5%
Math Symbol 1141
 
0.2%
Close Punctuation 955
 
0.2%
Open Punctuation 955
 
0.2%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
e 33420
11.6%
s 25916
 
9.0%
a 25025
 
8.7%
r 22909
 
8.0%
o 18765
 
6.5%
n 17752
 
6.2%
c 17585
 
6.1%
i 17407
 
6.1%
t 15676
 
5.5%
d 14498
 
5.0%
Other values (16) 78255
27.2%
Uppercase Letter
ValueCountFrequency (%)
T 12589
14.4%
D 8554
 
9.8%
H 7630
 
8.7%
E 7343
 
8.4%
R 6920
 
7.9%
B 5961
 
6.8%
A 4884
 
5.6%
P 4457
 
5.1%
S 3747
 
4.3%
N 3483
 
4.0%
Other values (13) 21786
24.9%
Other Punctuation
ValueCountFrequency (%)
/ 3353
29.7%
& 2564
22.7%
: 1656
14.7%
, 1098
 
9.7%
. 1073
 
9.5%
' 731
 
6.5%
\ 518
 
4.6%
? 170
 
1.5%
! 127
 
1.1%
Decimal Number
ValueCountFrequency (%)
0 11802
45.9%
2 10071
39.1%
1 1949
 
7.6%
8 666
 
2.6%
9 610
 
2.4%
5 279
 
1.1%
7 183
 
0.7%
4 169
 
0.7%
Space Separator
ValueCountFrequency (%)
54284
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2169
100.0%
Math Symbol
ValueCountFrequency (%)
| 1141
100.0%
Close Punctuation
ValueCountFrequency (%)
) 955
100.0%
Open Punctuation
ValueCountFrequency (%)
( 955
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 374562
79.5%
Common 96523
 
20.5%

Most frequent character per script

Latin
ValueCountFrequency (%)
e 33420
 
8.9%
s 25916
 
6.9%
a 25025
 
6.7%
r 22909
 
6.1%
o 18765
 
5.0%
n 17752
 
4.7%
c 17585
 
4.7%
i 17407
 
4.6%
t 15676
 
4.2%
d 14498
 
3.9%
Other values (39) 165609
44.2%
Common
ValueCountFrequency (%)
54284
56.2%
0 11802
 
12.2%
2 10071
 
10.4%
/ 3353
 
3.5%
& 2564
 
2.7%
- 2169
 
2.2%
1 1949
 
2.0%
: 1656
 
1.7%
| 1141
 
1.2%
, 1098
 
1.1%
Other values (12) 6436
 
6.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 471085
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
54284
 
11.5%
e 33420
 
7.1%
s 25916
 
5.5%
a 25025
 
5.3%
r 22909
 
4.9%
o 18765
 
4.0%
n 17752
 
3.8%
c 17585
 
3.7%
i 17407
 
3.7%
t 15676
 
3.3%
Other values (61) 222346
47.2%

Interactions

2023-01-12T09:12:52.757130image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:25.773734image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:28.442559image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:31.077241image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:33.661030image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:36.647899image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:39.466268image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:42.213513image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:44.753920image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:47.409221image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:49.975748image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:52.977634image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:26.016200image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:28.677407image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:31.304645image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:33.922506image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:36.872108image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:39.698059image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:42.422874image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:45.015469image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:47.665298image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:50.235929image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:53.206859image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:26.264373image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:28.920868image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:31.534170image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:34.211245image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:37.098034image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:39.962605image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:42.644104image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:45.267594image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:47.916396image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:50.510123image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:53.439310image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:26.496064image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:29.149685image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:31.749311image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:34.479426image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:37.319567image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:40.226061image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:42.863055image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:45.491740image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:48.136344image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:50.738121image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:53.708261image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:26.765308image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:29.395920image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:32.003512image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:34.777999image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:37.554864image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:40.502993image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:43.094322image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:45.726294image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:48.368587image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:51.034189image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:53.917686image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:26.990626image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:29.623287image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:32.226501image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:35.010248image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:37.769275image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:40.716382image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:43.310746image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:45.961811image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:48.579990image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:51.270703image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:54.148793image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:27.241151image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:29.863835image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:32.464945image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:35.286076image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:38.000545image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:40.960173image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:43.543002image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:46.177828image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:48.807617image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:51.507311image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:54.394421image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:27.485806image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:30.098929image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:32.699390image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:35.544455image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:38.222226image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:41.209126image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:43.805013image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:46.401814image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:49.026737image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:51.752619image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:54.732535image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:27.720540image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:30.333198image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:32.933541image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:35.851879image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:38.730807image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:41.483455image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:44.034257image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:46.622901image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:49.267672image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:52.000752image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:54.950641image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:27.952679image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:30.581837image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:33.166409image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:36.149219image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:38.967866image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:41.726855image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:44.266336image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:46.853283image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:49.519587image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:52.248874image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:55.200431image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:28.214539image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:30.850014image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:33.426422image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:36.416397image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:39.221642image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:41.998074image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:44.514197image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:47.147631image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:49.768644image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
2023-01-12T09:12:52.519621image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/

Correlations

2023-01-12T09:13:05.471049image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
danceabilityenergykeyloudnessspeechinessacousticnessinstrumentalnesslivenessvalencetempoduration_msmodetime_signaturegenre
danceability1.000-0.372-0.009-0.2650.2550.212-0.141-0.2320.358-0.239-0.1090.0860.0740.243
energy-0.3721.0000.0370.568-0.099-0.5340.3850.212-0.0500.0210.3100.0360.0600.227
key-0.0090.0371.000-0.006-0.015-0.0210.067-0.0110.027-0.0100.0650.4140.0150.078
loudness-0.2650.568-0.0061.0000.075-0.179-0.1410.1830.0830.244-0.0500.0260.0460.227
speechiness0.255-0.099-0.0150.0751.0000.285-0.4290.0730.2720.186-0.2950.0510.0510.187
acousticness0.212-0.534-0.021-0.1790.2851.000-0.508-0.0770.1910.091-0.3990.0260.0630.166
instrumentalness-0.1410.3850.067-0.141-0.429-0.5081.000-0.053-0.356-0.2280.5240.0330.0320.293
liveness-0.2320.212-0.0110.1830.073-0.077-0.0531.000-0.0300.087-0.0560.0000.0110.118
valence0.358-0.0500.0270.0830.2720.191-0.356-0.0301.0000.055-0.1900.0260.0340.183
tempo-0.2390.021-0.0100.2440.1860.091-0.2280.0870.0551.000-0.1260.0500.0650.420
duration_ms-0.1090.3100.065-0.050-0.295-0.3990.524-0.056-0.190-0.1261.0000.0800.0450.323
mode0.0860.0360.4140.0260.0510.0260.0330.0000.0260.0500.0801.0000.0060.169
time_signature0.0740.0600.0150.0460.0510.0630.0320.0110.0340.0650.0450.0061.0000.083
genre0.2430.2270.0780.2270.1870.1660.2930.1180.1830.4200.3230.1690.0831.000

Missing values

2023-01-12T09:12:55.539905image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-01-12T09:12:56.170633image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
2023-01-12T09:12:56.648020image/svg+xmlMatplotlib v3.6.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

danceabilityenergykeyloudnessmodespeechinessacousticnessinstrumentalnesslivenessvalencetempotypeduration_mstime_signaturegenresong_nametitle
00.8310.8142-7.36410.42000.05980.0134000.05560.3890156.985audio_features1245394Dark TrapMercury: RetrogradeNone
10.7190.4938-7.23010.07940.40100.0000000.11800.1240115.080audio_features2244274Dark TrapPathologyNone
20.8500.8935NaN10.06230.01380.0000040.37200.0391218.050audio_features988214Dark TrapSymbioteNone
30.4760.7810-4.71010.10300.02370.0000000.11400.1750186.948audio_features1236613Dark TrapProductOfDrugs (Prod. The Virus and Antidote)None
40.7980.6242-7.66810.29300.21700.0000000.16600.5910147.988audio_features1232984Dark TrapVenomNone
50.7210.5680-11.29510.41400.04520.2120000.12800.1090144.915audio_features1125114Dark TrapGattekaNone
60.7180.6688-4.16210.13700.02540.0078000.12400.0380130.826audio_features775844Dark Trapkamikaze (+ pulse)None
70.6940.7118NaN10.22100.03970.0000000.11200.2830138.049audio_features1275243Dark TrapT.R.U. (Totally Rotten Underground)None
80.7740.7511-2.44510.19800.06140.0000000.07280.1890219.960audio_features1403264Dark TrapI Put My Dick in Your MentalNone
90.8930.90711-10.40610.36700.15200.0311000.55800.3020199.942audio_features1219794Dark TrapAndromedaNone
danceabilityenergykeyloudnessmodespeechinessacousticnessinstrumentalnesslivenessvalencetempotypeduration_mstime_signaturegenresong_nametitle
428860.8750.7538-6.89900.09010.0405000.0000990.16800.7350112.002audio_features2101874Trap MetalSmoke BreakNone
428870.5890.7836-11.17010.04130.0004210.9160000.08390.0345123.995audio_features4103234technoNoneDark Techno Rave
428880.6230.8458-9.08210.05080.0160000.8640000.08620.3690134.978audio_features5467074tranceNoneTop Trance Songs EVER
428890.6740.9905NaN10.28400.3120000.0000160.62700.5090173.948audio_features1820694dnbNoneUKF Drum & Bass - All Uploads
428900.6530.9442NaN10.09170.0016300.4730000.35200.0754139.970audio_features2210004tranceNoneTRANNCE 2020 Best Trance Music Official
428910.8020.6309-9.34800.43200.2040000.0000020.06490.8770144.008audio_features667434Underground RapBang Bros!None
428920.5650.99611NaN00.06820.0000500.8160000.92200.0658145.000audio_features5908754psytranceNonePSYTRANCE BANGERS best new 2020
428930.5140.9550-5.18200.04020.0000530.8890000.33800.1100138.030audio_features2210074tranceNoneTop Trance Songs EVER
428940.7490.6391-9.84110.19400.0809000.6090000.36200.6490153.003audio_features2152024Underground RapSouthern HostilityNone
428950.6450.9800-6.89810.04450.0000290.8430000.31800.2600143.018audio_features4430774psytranceNonePsytrance: From Full on to Forrest Trance

Duplicate rows

Most frequently occurring

danceabilityenergykeyloudnessmodespeechinessacousticnessinstrumentalnesslivenessvalencetempotypeduration_mstime_signaturegenresong_nametitle# duplicates
4220.6310.6238-6.96910.26500.4630000.0000020.15100.7650160.460audio_features2278934HiphopEverything I AmNaN4
600.3890.7681-4.76510.25600.0380000.0000000.11900.334090.146audio_features1835674RapWRONG (feat. Lil Mosey)NaN3
980.4310.9612-6.59800.06030.0002460.2070000.36800.1630138.001audio_features2351874tranceNaNTRANNCE 2020 Best Trance Music Official3
1460.4730.73511-6.13100.04980.0106000.0000000.26600.6500154.546audio_features1794534EmoYou're So Last SummerNaN3
1500.4760.4074-9.23900.03680.2470000.0000000.14400.2260178.258audio_features2424674RnBOfficially Missing YouNaN3
1820.4950.8911-5.59900.05040.0018700.1120000.32200.2240149.982audio_features1424004hardstyleNaNEuphoric Hardstyle & Melodic Hardstyle3
2190.5130.8558-3.66410.03750.0293000.9330000.31600.0367173.996audio_features3641494dnbNaNLiquid Drum & Bass3
2850.5480.5549-6.40810.05870.2830000.0000000.07080.3820159.836audio_features2075074RnBStickwituNaN3
3010.5540.9784NaN10.13100.1110000.0000000.07310.5940135.095audio_features1626004EmoFaintNaN3
4190.6290.6961-5.57200.34800.0195000.0000000.05540.6230186.068audio_features2076274HiphopGold DiggerNaN3